UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BiHfQ8iHCXhqmvbv9NBQRM2fTaRf8yCtkuxEd5wnIE='
WHERE
key_id = '1472f2f483fd473610ce1a2bb7eba5f8595aee9dac11be79e21e9005130cf378'
AND (
token = '5BiHfQ8iHCXhqmvbv9NBQRM2fTaRf8yCtkuxEd5wnIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)