UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06gUZAXpt9SbsBGqAa7y/UKqynOj3AOYethOm6HDVMU='
WHERE
key_id = '19f59288e4d5005854fc9c49f762e36777557731c6f04b3773d5707af3a9068b'
AND (
token = '06gUZAXpt9SbsBGqAa7y/UKqynOj3AOYethOm6HDVMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)