UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Np9WKNqREHlI2pGocayN0ncXHz4tqi/tkiv6M4Yw3bg='
WHERE
key_id = '2de0f411a0d68492ba7e2ff3287f4a25182e89504ad64e50e5df47ba2436ffeb'
AND (
token = 'Np9WKNqREHlI2pGocayN0ncXHz4tqi/tkiv6M4Yw3bg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)