UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zEC8mfkk3Ggk8vBXITpKCUpXXW5NXPJ0pZm1KxnSvUM='
WHERE
key_id = '8e47fe57bd30dacd4f6435ea6f9391c135e3109e8524736349c625c2e630b3c5'
AND (
token = 'zEC8mfkk3Ggk8vBXITpKCUpXXW5NXPJ0pZm1KxnSvUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)