UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r6tUCEY2mC0NA8vmS/ACV3kZdFne1RLYmKSDcMu8PmY='
WHERE
key_id = 'b2393675e00379413abc91d41835f50bc23c91913b0571fe44dedad76ebe0890'
AND (
token = 'r6tUCEY2mC0NA8vmS/ACV3kZdFne1RLYmKSDcMu8PmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)