UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NFRH8ChflByNU3oriMEBPNeTH3uyZjkytHh6HGt3XT8='
WHERE
key_id = 'ab8577da8d74ad2a1df0a880d1600f1f1f33fc4039f98c9c5148be8ca4a2ba13'
AND (
token = 'NFRH8ChflByNU3oriMEBPNeTH3uyZjkytHh6HGt3XT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)