UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Waq3APDBfRac5iXgN7b9zswIXT1X5KvLyyAkoPxGGI='
WHERE
key_id = '1cf687753ecd74ee58b0979cddbe66ce53740ce7545e64ce684645e3a60a1694'
AND (
token = '6Waq3APDBfRac5iXgN7b9zswIXT1X5KvLyyAkoPxGGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)