UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1xxkncqkLAJz+WGlsss9TB1f+yExWCnyEO/I3bNKVw4='
WHERE
key_id = 'e63ba1b17214d56fcff5981b15b24d98dc0de7a88b57278185a819676ae60523'
AND (
token = '1xxkncqkLAJz+WGlsss9TB1f+yExWCnyEO/I3bNKVw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)