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