UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QAPjMFTy6YtX4XrHS0g5ze8dFCFbBu7gpYH6SEt+bMU='
WHERE
key_id = 'c6f685081d847962e857f8e0a95625a7308bebf7b994c213c836205b7cbb1979'
AND (
token = 'QAPjMFTy6YtX4XrHS0g5ze8dFCFbBu7gpYH6SEt+bMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)