UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aMIJhrONPqlgasiw3GtG7H3azfBICjESGgBa6J3pZaU='
WHERE
key_id = '4fcf6f30a0172274cdd2142b4a7abfcfbe2f15e8edc1f8dcaa009a4b112bcc02'
AND (
token = 'aMIJhrONPqlgasiw3GtG7H3azfBICjESGgBa6J3pZaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)