UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gdObP7azaB6a517kGoyq6Hg3i4JCEYZ75tBnIlFDkuI='
WHERE
key_id = 'e7cd500782faf873287f03e471c87547620d3e68bf71e3623e1c33b47af30b87'
AND (
token = 'gdObP7azaB6a517kGoyq6Hg3i4JCEYZ75tBnIlFDkuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)