UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fUEerpHStJFudkcLmvbi/x7Xz1KYmxibUKhsF4RTCMA='
WHERE
key_id = 'ffd6997d02da9e9b466f37ead7bbd4cf3c67e338cb187e6cd474e01e241cf4b6'
AND (
token = 'fUEerpHStJFudkcLmvbi/x7Xz1KYmxibUKhsF4RTCMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)