UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X2kvTrPevK1IvkmwkTNuPiCozcscEPG2k1z3zPGvkX8='
WHERE
key_id = 'a1cb1d26c6f8f51922949dc77563391464471c2bc322e4eded87768729326e38'
AND (
token = 'X2kvTrPevK1IvkmwkTNuPiCozcscEPG2k1z3zPGvkX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)