UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KA0aDXcxxxzH5RtVxfyZH8KTGR3ayKQzO/85d0i3rWM='
WHERE
key_id = '100a6a082b3653facef387c5bca7488c533e10560016f27024e3cbf54d6821d7'
AND (
token = 'KA0aDXcxxxzH5RtVxfyZH8KTGR3ayKQzO/85d0i3rWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)