UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCoNNRlh0sH9uM7Zqd+ZOZkxSoolfc3KJNXS8t5Hpp4='
WHERE
key_id = '1486ce6999e7c19ef17f3c082b2502a2981fc68667d39c6efdf3c813981a0788'
AND (
token = 'QCoNNRlh0sH9uM7Zqd+ZOZkxSoolfc3KJNXS8t5Hpp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)