UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VSAQnbkQtnjexuZXMOJkZD9/6d7w59RQYCjdsSw3aXQ='
WHERE
key_id = '04dd100651eb9906e1aa10c5647152b614a9f9a0e0cc1698f19af0647c43b757'
AND (
token = 'VSAQnbkQtnjexuZXMOJkZD9/6d7w59RQYCjdsSw3aXQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)