UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DY/IXjG2D0FpBejQLVN+HNwFAlT3HMeXMlAuEYf6iV0='
WHERE
key_id = '8c44af07d19a784a0b34a3cd165659d1d2f27568278e9b8f0937f3b98102b145'
AND (
token = 'DY/IXjG2D0FpBejQLVN+HNwFAlT3HMeXMlAuEYf6iV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)