UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TJrpsTBqARiLVyiKJQ+rqx+T3CkxVUNMvw41PzDHgv8='
WHERE
key_id = '527a7912b6b73f6630f208c6f2cbf241630c74978b26f1021a6f6911811987c9'
AND (
token = 'TJrpsTBqARiLVyiKJQ+rqx+T3CkxVUNMvw41PzDHgv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)