UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zMWKIDRudCFTRUT9vJo0bB80gkZD+ZSG4BxkY9yVsHM='
WHERE
key_id = '23aec5902a5b0ad17f1481850052af9efde839be2f8e2c2c7d0097f767889bf1'
AND (
token = 'zMWKIDRudCFTRUT9vJo0bB80gkZD+ZSG4BxkY9yVsHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)