UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SGxgkOu5V35Bx3kcldiS9c8f/aGggy2IFFN2sIhYckM='
WHERE
key_id = '5a7f525f5c5f267101899ac75fc67d57b0cf743c7e7a256102f9a7776417b77d'
AND (
token = 'SGxgkOu5V35Bx3kcldiS9c8f/aGggy2IFFN2sIhYckM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)