UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6jgi8oxEDSDeg3OxEXzqamZMDoxRk+dn90aEP8GHFz8='
WHERE
key_id = '489438a78c31a3119dd050977cded8dbbb6d1c356e203fe4edb37d564840bd17'
AND (
token = '6jgi8oxEDSDeg3OxEXzqamZMDoxRk+dn90aEP8GHFz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)