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