UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQW42DGvOPTk2fIHGB2cuvDOWYSLX+CbpUoDuzUb1K4='
WHERE
key_id = '168c48bdbe637f3693c6aaa1c67e89ccb414f99edaa1ffe8c2ff1d71540ab05a'
AND (
token = 'ZQW42DGvOPTk2fIHGB2cuvDOWYSLX+CbpUoDuzUb1K4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)