UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTL0uf9dNL0mwvYqIxoiZAAAyI7DEPcsm7/hySM6vzw='
WHERE
key_id = '7f716766c3a0e2ed6427be64f2a707694fa85d86ca3e1e0de1470f582f17d07e'
AND (
token = 'CTL0uf9dNL0mwvYqIxoiZAAAyI7DEPcsm7/hySM6vzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)