UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jxl7TIptAl2CgKu7yDO3IsGM6OdTHsV00pJ072ZZcg='
WHERE
key_id = 'b54cc63d63c2e72af893d42c87d03c170dc272d5f64ead38d4ea665720391fee'
AND (
token = '9jxl7TIptAl2CgKu7yDO3IsGM6OdTHsV00pJ072ZZcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)