UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKzh5XWio2OA2Aa7nmEY4h7GpfmhNDyXu2QYkbolaAY='
WHERE
key_id = '994724e52fd70cc0ecae4bc5ab108832598ef3228619906fc1aa26fae3932710'
AND (
token = 'zKzh5XWio2OA2Aa7nmEY4h7GpfmhNDyXu2QYkbolaAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)