UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5KNXyzOvqkoeKyqoraNkSEjEYCG6DL6CS1RHuFnIKtU='
WHERE
key_id = 'b854b3a1bf149fce0308d6f8d318b2b06c05c4d75fb6da15d4e7e0d2635742cd'
AND (
token = '5KNXyzOvqkoeKyqoraNkSEjEYCG6DL6CS1RHuFnIKtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)