UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xpnd+JjGVQU5S++3b7wgAPceM3Aab2VkV8jBLrkOsak='
WHERE
key_id = 'a9eac98dcf1d9390c5b21d967d76d6c96224197185e83bee3236ba6018e432b8'
AND (
token = 'Xpnd+JjGVQU5S++3b7wgAPceM3Aab2VkV8jBLrkOsak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)