UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'of9jat+icK9UB9hEFj0STJDrm2xGcm6bmmrCazEnP3E='
WHERE
key_id = 'd64aceba7e3de894108219b2b7f3f3c6c7649deb29319319c5a7b1b77e770e3f'
AND (
token = 'of9jat+icK9UB9hEFj0STJDrm2xGcm6bmmrCazEnP3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)