UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I5fADTgSj7RA94tFKIIs/7oqq9Y/LaInQsrmG7tmUsY='
WHERE
key_id = '02eb7f15684e0f589424ec1e837956eed1b0affb18e4a79e950c40ae8941fc40'
AND (
token = 'I5fADTgSj7RA94tFKIIs/7oqq9Y/LaInQsrmG7tmUsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)