UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9GZsSIuLL5z8lUwjDTbOJSKd608sKFSF4vNaU/bDY9M='
WHERE
key_id = '20f274fd98265acca247e4f8bc574f7421f05602b83821c62e4acdf9ffb7863d'
AND (
token = '9GZsSIuLL5z8lUwjDTbOJSKd608sKFSF4vNaU/bDY9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)