UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pV43CTtodwH6q0HY2q3QgW718SoYwKbjUyTVtpNH8bk='
WHERE
key_id = '51d775242bba99bc46f3254c920973df45e1a8372841f8e17749c53e5eb68193'
AND (
token = 'pV43CTtodwH6q0HY2q3QgW718SoYwKbjUyTVtpNH8bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)