UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eMiO6wgwNPCq1dGG8D12p1OgtNfxKjPWl6q+Sflo+D4='
WHERE
key_id = 'b78169a46c1f77472998a098188c69a58a9ab6793de644c0535e769e8384220d'
AND (
token = 'eMiO6wgwNPCq1dGG8D12p1OgtNfxKjPWl6q+Sflo+D4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)