UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pv9UvduR+sFbSZagox7ndqX0rx8jyc2XDYJ6ZSgCRV0='
WHERE
key_id = 'f18f3a62766cfbe2ee7a97f70527a215857efc5c3b941529836cd1a8f636769c'
AND (
token = 'pv9UvduR+sFbSZagox7ndqX0rx8jyc2XDYJ6ZSgCRV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)