UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KlV5ne/h7Uw+B4fA9/BwTgYpFJBgjivKx/3qwDhs8gc='
WHERE
key_id = '7e9ca8544ed188954a4a8160344899835799c0a2735a65e3c8b935576ddc1fa8'
AND (
token = 'KlV5ne/h7Uw+B4fA9/BwTgYpFJBgjivKx/3qwDhs8gc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)