UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ABTNHyrh+bJ66JhP5vh6SLrOkeip2uKPs6CQSm/mdjI='
WHERE
key_id = 'f9f4787ce120fac1567975758cbbeb5b1c9a16d47808cf2791acab7964539af5'
AND (
token = 'ABTNHyrh+bJ66JhP5vh6SLrOkeip2uKPs6CQSm/mdjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)