UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6znHpwOTfb6JYWvuAyVnajvNW8j/6NrSNXvqArRdS08='
WHERE
key_id = '59bde11204e117a09b5f98a120edabe3c9004aed56165999a87f35c3e513a8bb'
AND (
token = '6znHpwOTfb6JYWvuAyVnajvNW8j/6NrSNXvqArRdS08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)