UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SXsawwCPCQoGIOCSwBbWGvHNwF6D0NHwN272UDYO5I4='
WHERE
key_id = '6ffdb78003bea4ef5e201a61f7bdc6f221fd1d2cd683fd3554d7e6f1b255fe27'
AND (
token = 'SXsawwCPCQoGIOCSwBbWGvHNwF6D0NHwN272UDYO5I4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)