UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+pDKUlKMQyKCig+aTgUKIjSOwWJCJR2FLxhqbnjJTUw='
WHERE
key_id = '9570d3241259f30f238a35e7bfe5699e158db7a331104eb45ce4a53283323134'
AND (
token = '+pDKUlKMQyKCig+aTgUKIjSOwWJCJR2FLxhqbnjJTUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)