UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Q4JqzA4eTHbLq+v3UWvcbgW+B5PiQ7W/gJLkoJAou0='
WHERE
key_id = 'f7407cd38d457b27355964b0bac3294edfbe9063071839890ccaad0782a94c2a'
AND (
token = '4Q4JqzA4eTHbLq+v3UWvcbgW+B5PiQ7W/gJLkoJAou0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)