UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KhD0pf2g4uickED0pO+hKSRIPNrupfWXLMnMuI3s5lU='
WHERE
key_id = 'f18a8d223b2f41a8c72b4f482732201b7804fab7e9c65d91af206ec66d447e48'
AND (
token = 'KhD0pf2g4uickED0pO+hKSRIPNrupfWXLMnMuI3s5lU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)