UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aidPwyrX+eJAOaFWYjHwAghVXcrG1koYLhLkqA7bIUc='
WHERE
key_id = '70cf480c67697eb9fdf512ddc3dc29ae8c0b31fcc74535ad456ce2cfbcfcc392'
AND (
token = 'aidPwyrX+eJAOaFWYjHwAghVXcrG1koYLhLkqA7bIUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)