UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8a3rCQAL3oeMHGId5R37rnZcCAAcQx9J64PB0qKxo0E='
WHERE
key_id = '2c9ba1a166211277f3f3a0ddd5f72ed2282668a006b8f35856b6e4171215ccbe'
AND (
token = '8a3rCQAL3oeMHGId5R37rnZcCAAcQx9J64PB0qKxo0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)