UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/PiDhXG+E4vdUKpP/9L/wjbfbSiUmJuvouc94WZiYsY='
WHERE
key_id = 'af1a052dfdd4aa4b9e0c18e50028b901e2e9d63b2ea04c5f1e7b36aaaa87bc71'
AND (
token = '/PiDhXG+E4vdUKpP/9L/wjbfbSiUmJuvouc94WZiYsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)