UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9TO7qfcb+Ml6cJKCIVW/N0h8npDvZiwfJazZkdOn3lA='
WHERE
key_id = 'd1965f78d77c4d37a7e0afdf34754da11f5b2b8ca8263a3f4d79d4f2dc0cc642'
AND (
token = '9TO7qfcb+Ml6cJKCIVW/N0h8npDvZiwfJazZkdOn3lA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)